Create Drill Through Pages 12

Create Drill throughs Pages


Create Member sign up Name Drill throughs

·      ·      Open new page 



 

Member sign up Name table

·       Date

·       Member Name (Members table)

·       Referral Name (Members table) After select Go to the value and right click and change to count

 

Formatting

·       Style

                         -Bold header flashy rows

·       Value            

                        -Font color – white

                        -Background color – (# 836d52)

                        -Alternate font color – white

                        -Alternate Background color (#108372)

                        -Title – click FX and choose - Field value

                                                                        - Member Page Title 



Member Signup All-Time Record

·        Member Name

·        Referrals Signup

·        . Total commission

·        AVG Time for 1st

Formatting

·        Style

                         -Bold header flashy rows

·        Value            

                        -Font color – white

                        -Background color – (# 836d52)

                        -Alternate font color – white

                        -Alternate Background color (#108372)

                        -Title – Member Sign-Up All-Time Record

Create Member sign up Name Drill throughs KPI’S

KPI 1

·       Select Card Visualization

·       Drag and Drop ThisMth vs AVGMthlySignup

 

Formatting

·       Data the label put below formatting

 

 

 

KPI 2

 

·       Select Card Visualization

·       Drag and Drop Member Sign Up per Month

KPI 3

 

·       Select Card Visualization

·       Drag and Drop AVG Member Per Month

·   

 

KPI 4

 

·       Select Card Visualization

·       Drag and Drop AVG Time for 1st Reward


Create search Visual

·       Select the Text filter

·       Drag and Drop Member name on the field from member table 

 

Referrals Enrollment Drill- through 

·      Open new page


Referrals Enrollment Table

 

·        Date

·        Referral Name

·        RFM_ Paid Tuition

·        RFM_ In Class 30days

·        Status

·        RFM_IPBC

·        RFM_JRP

·        RFM_ Placement

·        Post Job Payment

·        Post 10 days login

Formatting

·        Style

                         -Bold header flashy rows

·        Value            

                        -Font color – white

                        -Background color – (# 836d52)

                        -Alternate font color – white

                        -Alternate Background color (#108372)

                       -Title – click FX and choose - Field value

                                                                          - Referral Page Title   

Create Referrals Enrollment Drill- through KPI's

KPI 1

 

·       Select Card Visualization

·       Drag and Drop ThisMth vs AVGMthlyEnrollment

 

 

Formatting

·       Data label put below formatting

 

 

 

KPI 2

 

·       Select Card Visualization

·       Drag and Drop Referral Enrollment per Month

KPI 3

 

·       Select Card Visualization

·       Drag and Drop AVG Enrolled Per Month

KPI 4

 

·       Select Card Visualization

·       Drag and Drop % Complete  

Create search Visual

·       Select the Text filter

·       Drag and Drop Member name on the field from member table 

 

 

Reward Payout Drill-Through

     ·      Open new page 


·       Reward level 1

-     Commission 1 Reached (Commission 1 table)

-     Member Name (Commission 1 table)

-     First Reward (Calculated table)

Formatting

·        Style

                         -Bold header flashy rows

·        Value            

                        -Font color – white

                        -Background color – (# 836d52)

                        -Alternate font color – white

                        -Alternate Background color (#108372)

                        -Title – click FX and choose - Field value

                                                                          - RL1 Page Title

 

·       Reward level 2

-     Commission 2 Reached (Commission 2 table)

-     Member Name (Commission 2 table)

-     Second Reward (Calculated table)

Formatting

·        Style

                         -Bold header flashy rows

·        Value            

                        -Font color – white

                        -Background color – (# 836d52)

                        -Alternate font color – white

                        -Alternate Background color (#108372)

                        -Title – click FX and choose - Field value

                                                                          - RL2 Page Title

·       Total Payout

-Choose Stacked bar chart

    - Axis       -Date

    - Values    -Total payout

Formatting

·        Y-Axis

                         -Categorical

        

·        Data Color       -(# 836d52)

·        Data labels      -ON

·        Title – click FX and choose - Field value

                                                 - Total Payout Title 




Create Reward Payout Drill-Through Kip’s

KPI 1

 

·       Select Card Visualization

·       Drag and Drop ThisMth vs AVGMthlyPayout



 

 

Formatting

·       Data label put below formatting

 

 

 

KPI 2

 

·       Select Card Visualization

·       Drag and Drop Referral Payout per Month

·       Rename the name to Payout per Month

 

KPI 3

 

·       Select Card Visualization

        ·       Drag and Drop Avg Payout Per Month 

Create search Visual

·       Select the Text filter

·       Drag and Drop Member name on the field from member table 


ROI Details Drill-through

·      Open new page



Create a Total Cost Element

-Choose Line and Stacked bar chart

    - Shared Axis       -Date

    - Column Values    -Total payout

    - Line Values          - Program cost

Formatting

·       Y-Axis

                         -Categorical

        

·       Data Color     

                                    - Program cost    - (#b5411e)

          - Default color      - (# 836d52)

           

                     -(# 836d52)

·       Data labels      -ON

·       Title – click FX and choose - Field value

                                                 - TCE ROI Page Title 


Create Tuition Visual

 

-Choose Stacked bar chart

    -  Axis       -Date

    - Values    -Total Tuition

  

Formatting

·       Y-Axis

                         -Categorical

        

·       Data Color     

                                    - Default color      - (# 836d52)

           

·       Data labels      -ON

·       Title – click FX and choose - Field value

                                                 - TT ROI Page Title

 

Create ROI Details

-Choose Tornado visual

    -  Group      -Date

    - Values    -Total Tuition

                      - ROI per month

  

Formatting

        

·       Data Color     

                                    - Total Tuition      - (# 836d52)

                                     - ROI per month   -(#b5411e)

 

·       Data labels      -ON

·       Title – click FX and choose - Field value

                                                 - ROI Page Title 


Create ROI Details Drill-through KPI's

KPI 1

 

·       Select Card Visualization

·       Drag and Drop ThisMth vs AVGMthlyROI

 

 

Formatting

·       Data label put below formatting

 

 

 

KPI 2

 

·       Select Card Visualization

·       Drag and Drop ROI per Month

KPI 3

 

·       Select Card Visualization

·       Drag and Drop AVG ROI Per Month

below link help  to create drill-through report in power bi 

https://www.youtube.com/watch?v=q_o342K9JGA